Release 10.1A: OpenEdge Data Management:
Database Administration

PROMON Database Status option

Displays database block usage statistics and general status information. Figure 19–8 shows an example of this option’s output.

Database version number: 1174                                Database state: Open (1)                        Database damaged flags: None (0)                               Integrity flags: Executing with -r (0)                   Database block size (bytes): 1024               Total number of database blocks: 1417               Database blocks high water mark: 1375             Free blocks below high water mark: 116                 Record blocks with free space: 3               Before image block size (bytes): 8192                Before-image cluster size (kb): 512                After image block size (bytes): 8192                         Last transaction number: 169                     Highest file number defined: 0                  Database create (multi-volume): 03/25/04 16:05                       Most recent database open: 06/04/04 14:19                          Previous database open: 06/04/04 14:19                   Local Schema cache time stamp: 03/24/04 20:47                       Most recent .bi file open: 06/04/04 14:20            RETURN - show remaining, U - continue uninterrupted, Q - quit:                          Previous .bi file open: - -                     Time since last truncate bi: 0 (seconds)                         Most recent full backup: 05/26/04 15:06                   Database changed since backup: Yes                  Most recent incremental backup: - -                    Sequence of last incremental: 0        RETURN - repeat, U - continue uninterrupted, Q - quit

Figure 19–8: Sample output for PROMON Database Status option

Because most of the Database Status option output is self-explanatory, this list describes only five items:

Database state

One of the following values, set in the database master block:

Database state	Description
1	The database is open.
2	The database is closed, used on disk.
3	The database is being recovered.

Total number of database blocks

The actual database size in disk blocks.

Number of empty blocks

The number of empty blocks in the database. Empty blocks are created when the database outgrows its existing block allocation, and also by record and index deletion. The database engine expands the database by multiple blocks at a time—usually 8 or 16—and most of these are empty at first. Typically, the number of empty blocks increases and decreases as the database grows.

Record blocks with free space

Free space is created when records are deleted and when the database grows into a new block, but does not use the entire block. The database engine reuses empty space with new records when possible, but does not return empty space to the operating system. This space does not affect database performance. However, if you must reclaim this disk space for your system, you can dump and reload the database.

Time since last truncate bi

The time in seconds since the before-image file was truncated. When the BI file is truncated, all modified database blocks are written to disk.